IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CreatorGetRoleForSaga')
	BEGIN
		DROP  Procedure  CreatorGetRoleForSaga
	END

GO

CREATE Procedure CreatorGetRoleForSaga
@SagaID INT,
@CreatorID INT
AS
SELECT 
SagaRoleID 
FROM SagaCreators
Where CreatorID = @CreatorID AND SagaID =@SagaID

GO



 